and gu.f_lotid=rec_viplotplay.f_lotid
oracle 不懂先把数据给过滤掉然后在来连接吗？ 太笨了！而且这样把符合条件的数据也过滤掉了 left join
HASH UNIQUE

and vu.f_username is null

NESTED LOOPS OUTER
where b.f_username is null
TABLE ACCESS FULL Object name=T_BASE_VIP_CUSTOMES
FILTER

复制代码 代码如下:

复制代码 代码如下:

SELECT /*+parallel(gu,4)*/distinct gu.f_username
SELECT /*+parallel(gu,4)*/distinct gu.f_username

and ((vu.f_condtionid is null ) or (vu.f_condtionid=rec_viplotPlay.F_CondtionID))
and ((vu.f_passeddate is null ) or (vu.f_passeddate > trunc(sysdate,'Y') ))
on A.f_username=B.f_usernam
and ((vu.f_playid is null ) or (vu.f_playid=4))
gu.f_expectenddate > (select trunc(sysdate,'Y')FROM DUAL)
and ((vu.f_playid is null ) or (vu.f_playid=rec_viplotPlay.f_Playid))

VIEW
TABLE ACCESS BY GLOBAL INDEX ROWID Object name=T_BASE_SUCCPROUSER
where gu.f_expectenddate > (select trunc(sysdate,'Y')FROM DUAL)
PARTITION RANGE ALL
VIEW
HASH UNIQUE
and ((vu.f_passeddate is null ) or (vu.f_passeddate > trunc(sysdate,'Y') ))
SELECT STATEMENT, GOAL = ALL_ROWS
FAST DUAL
FILTER
and gu.f_playid=rec_viplotPlay.f_Playid
from
SELECT /*+parallel(gu,4)*/distinct gu.f_username
and gu.f_paymoney>=rec_viplotPlay.F_Conditon_ValuesA
and ((vu.f_condtionid is null ) or (vu.f_condtionid=3))
and ((vu.f_playid is null ) or (vu.f_playid=rec_viplotPlay.f_Playid))
(
and gu.f_lotid=1
and ((vu.f_condtionid is null ) or (vu.f_condtionid=rec_viplotPlay.F_CondtionID))
NESTED LOOPS OUTER
TABLE ACCESS FULL Object name=T_BASE_SUCCPROUSER
)B
FROM t_base_succprouser gu
FROM t_base_succprouser gu
(
and gu.f_paymoney>=rec_viplotPlay.F_Conditon_ValuesA
) A
FROM t_base_succprouser gu

复制代码 代码如下:

复制代码 代码如下: